sqlx4k-sqlite/io.github.smyrgeorge.sqlx4k.sqlite/[native]SQLite

SQLite

class SQLite(url: String, options: ERROR CLASS: Symbol not found for ConnectionPool.Options = ConnectionPool.Options(), val encoders: ERROR CLASS: Symbol not found for ValueEncoderRegistry = ValueEncoderRegistry()) : ISQLite(source)

A database driver for SQLite, implemented with connection pooling and transactional support. This class provides mechanisms to execute SQL queries, manage database connections, and handle transactions in a coroutine-based environment.

sqlite::memory: | Open an in-memory database. sqlite:data.db | Open the file data.db in the current directory. sqlite://data.db | Open the file data.db in the current directory. sqlite:///data.db | Open the file data.db from the root (/) directory. sqlite://data.db?mode=ro | Open the file data.db for read-only access.

Parameters

url

The URL string for connecting to the SQLite database.

options

Configuration options for the connection pool, such as minimum and maximum connections, timeout durations, etc.

encoders

Optional registry of value encoders to use for encoding query parameters.

Constructors

SQLite

constructor(url: String, options: ERROR CLASS: Symbol not found for ConnectionPool.Options = ConnectionPool.Options(), encoders: ERROR CLASS: Symbol not found for ValueEncoderRegistry = ValueEncoderRegistry())

Types

SqlxConnection

class SqlxConnection(rt: ERROR CLASS: Symbol not found for CPointer<out ERROR CLASS: Symbol not found for CPointed>, cn: ERROR CLASS: Symbol not found for CPointer<out ERROR CLASS: Symbol not found for CPointed>, val encoders: ERROR CLASS: Symbol not found for ValueEncoderRegistry) : <ERROR CLASS> ERROR CLASS: Symbol not found for Connection

SqlxTransaction

class SqlxTransaction(rt: ERROR CLASS: Symbol not found for CPointer<out ERROR CLASS: Symbol not found for CPointed>, tx: ERROR CLASS: Symbol not found for CPointer<out ERROR CLASS: Symbol not found for CPointed>, val encoders: ERROR CLASS: Symbol not found for ValueEncoderRegistry) : <ERROR CLASS> ERROR CLASS: Symbol not found for Transaction

Properties

encoders

open override val encoders: ERROR CLASS: Symbol not found for ValueEncoderRegistry

Functions

acquire

open suspend override fun acquire(): ERROR CLASS: Symbol not found for Result<ERROR CLASS: Symbol not found for Connection>

begin

open suspend override fun begin(): ERROR CLASS: Symbol not found for Result<ERROR CLASS: Symbol not found for Transaction>

open suspend override fun close(): ERROR CLASS: Symbol not found for Result<kotlin/Unit>

execute

open suspend override fun execute(sql: String): ERROR CLASS: Symbol not found for Result<kotlin/Long>

fetchAll

open suspend override fun fetchAll(sql: String): ERROR CLASS: Symbol not found for Result<ERROR CLASS: Symbol not found for ResultSet>

migrate

open suspend override fun migrate(supplier: () -> List<ERROR CLASS: Symbol not found for MigrationFile>, table: String, schema: String?, createSchema: Boolean, afterStatementExecution: suspend (ERROR CLASS: Symbol not found for Statement, ERROR CLASS: Symbol not found for Duration) -> Unit, afterFileMigration: suspend (ERROR CLASS: Symbol not found for Migration, ERROR CLASS: Symbol not found for Duration) -> Unit): ERROR CLASS: Symbol not found for Result<ERROR CLASS: Symbol not found for Migrator.Results>

open suspend override fun migrate(path: String, table: String, schema: String?, createSchema: Boolean, afterStatementExecution: suspend (ERROR CLASS: Symbol not found for Statement, ERROR CLASS: Symbol not found for Duration) -> Unit, afterFileMigration: suspend (ERROR CLASS: Symbol not found for Migration, ERROR CLASS: Symbol not found for Duration) -> Unit): ERROR CLASS: Symbol not found for Result<ERROR CLASS: Symbol not found for Migrator.Results>

open suspend override fun migrate(files: List<ERROR CLASS: Symbol not found for MigrationFile>, table: String, schema: String?, createSchema: Boolean, afterStatementExecution: suspend (ERROR CLASS: Symbol not found for Statement, ERROR CLASS: Symbol not found for Duration) -> Unit, afterFileMigration: suspend (ERROR CLASS: Symbol not found for Migration, ERROR CLASS: Symbol not found for Duration) -> Unit): ERROR CLASS: Symbol not found for Result<ERROR CLASS: Symbol not found for Migrator.Results>

poolIdleSize

open override fun poolIdleSize(): Int

poolSize

open override fun poolSize(): Int